Best Of
Re: Copying action while building Automation
Similar request https://community.smartsheet.com/discussion/105426/automation-workflow-action-condition-drag-and-drop-copy-and-paste?_gl=11lztxdq_gcl_auMTI2ODY5MDkwMS4xNzQxODgyNDUy_gaMzQ4MDE5ODk5LjE3MzgwMjYyODg._ga_ZYH7XNXMZK*MTc0MjM1MTUzNS4xOS4xLjE3NDIzNTE3MjguNDMuMC4w

Re: Copying action while building Automation
When making larger, and more detailed, automation workflows, it would be nice if they ability to either copy or move a Condition or Action box to another location.
Re: How to flag duplicate dates within a range
Putting this in a flag type column should do the trick:
=IF(COUNTIFS([Annual Leave Start Date]:[Annual Leave Start Date], @cell <= [Annual Leave End Date]@row, [Annual Leave End Date]:[Annual Leave End Date], @cell >= [Annual Leave Start Date]@row) > 1, 1)

Re: Deactivate all automation on a sheet
Would be nice as projects get closed, we could turn off all automations within the projects folder in one toggle than heading into each asset to deactivate.

User name display
Hi
I am adding new users to smartsheet but would prefer that their first and last names show and not just their email addresses.Β This happens even if I add them to my contacts?
Is there something that I am not doing correctly? which is not allowing the display of their names the way we want it.
Any assistance is appreciated.
thanks

Re: Copying action while building Automation
<sigh> another basic capability that should have been available years ago

Re: Happy 10th Anniversary Community + Giveaway!
A big thank you to everyone who celebrated 10 years of Community with us, we appreciate having you all here making the Community a great place for all Smartsheet users.
Now, the moment we were all waiting for. We're ready to announce the winner of the giveaway. π
The grand winner of the Anniversary giveaway isβ¦ @Michelle Choate 2!! Congratulations Michelle! We'll be reaching out to make sure you get your prize. π€©
Thank you once again to everyone for celebrating this milestone together with us, and for sharing your responses to the prompt!

Re: User-Created Dashboard Color Schemes
I agree with Terry Lewis, it is frustrating when color choice is forgotten.

Re: Automate reminders for Update Requests
I agree that some kind of automatically recurring reminders "until they do what they're supposed to" are needed. This could (and should) also apply to the Approval workflow.
The current workaround of setting up multiples upon multiples of automations "in case" someone doesn't provide the required info is too cumbersome and can quickly push you up against the # of automation limit.

Re: Automate reminders for Update Requests
This is exaclty right! The ability to manually resend when necessary, automated reminders for pending requests, reports of pending requests, and notifications for managers so follow can happen.
Love the collaboration here!
